if exists (select * from sys.objects WHERE object_id = object_id(N'[foo].[foo_maps]') AND type in (N'U'))
drop table [foo].[foo_maps];
go

if exists (select * from sys.objects WHERE object_id = object_id(N'[foo].[foo_other_bars]') AND type in (N'U'))
drop table [foo].[foo_other_bars];
go

if exists (select * from sys.objects WHERE object_id = object_id(N'[foo].[foo_bars]') AND type in (N'U'))
drop table [foo].[foo_bars];
go

if exists (select * from sys.objects WHERE object_id = object_id(N'[foo].[do_not_overwrite_this_type]') AND type in (N'U'))
drop table [foo].[do_not_overwrite_this_type];
go

if exists (select * from sys.objects WHERE object_id = object_id(N'[foo].[foo_types]') AND type in (N'U'))
drop table [foo].[foo_types];
go
